<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@include file="../WEB-INF/jspf/controlesessao.jspf"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Lista formacoes</title>
        <script type="text/javascript" src="../js/jquery.js" ></script>
        <script type="text/javascript" src="../js/jquery.validate.js"></script>
        <script type="text/javascript" src="../js/jquery.tablescroll.js"></script>
        <script type="text/javascript" src="../js/forms.js"></script>
        <script type="text/javascript" src="../js/jquery-ui-1.8.2.custom.min.js" ></script>
        <link rel="stylesheet" href="../css/ui-lightness/jquery-ui-1.8.2.custom.css">
    <link rel="stylesheet" href="../css/forms.css"></head>

    <body>
           <div id="formulario">
   <h1>Listar formacoes</h1>
        <sql:query var="query" dataSource="jdbc/dbo_MicrosoftSQLServer">
            SELECT  * FROM formacoes
        </sql:query>
        <table cellspacing="0">  <thead>
                <th> ID </th>
                <th>matricula</th>
                <th>id_cursosF</th>
                <th>pdca</th>
                <th>valor</th>
                <th>anoconclusao</th>
            </thead>
            <tfoot>
                <tr>
                    <td colspan="6">
                        ${query.rowCount} registros encontrados
                    </td>
                </tr>
            </tfoot>
            <c:forEach var="row" items="${query.rows}">
                <tr><td>${row.matricula}</td>
                    <td>${row.id_cursosF}</td>
                    <td>${row.pdca}</td>
                    <td>${row.valor}</td>
                    <td>${row.anoconclusao}</td>
                </tr></c:forEach>
            </table>
             <script>
            jQuery(document).ready(function($)
            {
                $('table').tableScroll({height:300});

            });
        </script>
        </div>
        </body>
    </html>
